Overview
Brought to you by YData
Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 4803 |
| Missing cells | 3941 |
| Missing cells (%) | 3.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 863.2 KiB |
| Average record size in memory | 184.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Unsupported | 2 |
| Text | 8 |
| Categorical | 3 |
| DateTime | 1 |
budget is highly overall correlated with popularity and 3 other fields | High correlation |
label is highly overall correlated with vote_average and 1 other fields | High correlation |
popularity is highly overall correlated with budget and 3 other fields | High correlation |
popularity_scaled is highly overall correlated with budget and 3 other fields | High correlation |
revenue is highly overall correlated with budget and 3 other fields | High correlation |
vote_average is highly overall correlated with label and 1 other fields | High correlation |
vote_average_scaled is highly overall correlated with label and 1 other fields | High correlation |
vote_count is highly overall correlated with budget and 3 other fields | High correlation |
original_language is highly imbalanced (88.8%) | Imbalance |
status is highly imbalanced (98.8%) | Imbalance |
homepage has 3091 (64.4%) missing values | Missing |
tagline has 844 (17.6%) missing values | Missing |
id has unique values | Unique |
genres is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
spoken_languages is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
budget has 1037 (21.6%) zeros | Zeros |
revenue has 1427 (29.7%) zeros | Zeros |
vote_average has 63 (1.3%) zeros | Zeros |
vote_count has 62 (1.3%) zeros | Zeros |
vote_average_scaled has 63 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-23 12:16:06.489137 |
|---|---|
| Analysis finished | 2024-11-23 12:16:40.590814 |
| Duration | 34.1 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
budget
Real number (ℝ)
High correlation Zeros
| Distinct | 436 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29045040 |
| Minimum | 0 |
|---|---|
| Maximum | 3.8 × 108 |
| Zeros | 1037 |
| Zeros (%) | 21.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 790000 |
| median | 15000000 |
| Q3 | 40000000 |
| 95-th percentile | 1.15 × 108 |
| Maximum | 3.8 × 108 |
| Range | 3.8 × 108 |
| Interquartile range (IQR) | 39210000 |
Descriptive statistics
| Standard deviation | 40722391 |
|---|---|
| Coefficient of variation (CV) | 1.4020429 |
| Kurtosis | 7.6580602 |
| Mean | 29045040 |
| Median Absolute Deviation (MAD) | 15000000 |
| Skewness | 2.437211 |
| Sum | 1.3950333 × 1011 |
| Variance | 1.6583131 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1037 | 21.6% |
| 20000000 | 144 | 3.0% |
| 30000000 | 128 | 2.7% |
| 25000000 | 126 | 2.6% |
| 40000000 | 123 | 2.6% |
| 15000000 | 120 | 2.5% |
| 35000000 | 102 | 2.1% |
| 50000000 | 101 | 2.1% |
| 10000000 | 101 | 2.1% |
| 60000000 | 86 | 1.8% |
| Other values (426) | 2735 |
| Value | Count | Frequency (%) |
| 0 | 1037 | |
| 1 | 7 | 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 3 | 0.1% |
| 11 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 380000000 | 1 | < 0.1% |
| 300000000 | 1 | < 0.1% |
| 280000000 | 1 | < 0.1% |
| 270000000 | 1 | < 0.1% |
| 260000000 | 2 | < 0.1% |
| 258000000 | 1 | < 0.1% |
| 255000000 | 1 | < 0.1% |
| 250000000 | 8 | |
| 245000000 | 1 | < 0.1% |
| 237000000 | 1 | < 0.1% |
genres
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
homepage
Text
Missing
| Distinct | 1691 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 3091 |
| Missing (%) | 64.4% |
| Memory size | 37.6 KiB |
Length
| Max length | 138 |
|---|---|
| Median length | 80 |
| Mean length | 36.419977 |
| Min length | 17 |
Unique
| Unique | 1677 ? |
|---|---|
| Unique (%) | 98.0% |
Sample
| 1st row | http://www.avatarmovie.com/ |
|---|---|
| 2nd row | http://disney.go.com/disneypictures/pirates/ |
| 3rd row | http://www.sonypictures.com/movies/spectre/ |
| 4th row | http://www.thedarkknightrises.com/ |
| 5th row | http://movies.disney.com/john-carter |
| Value | Count | Frequency (%) |
| http://www.missionimpossible.com | 5 | 0.3% |
| http://www.transformersmovie.com | 4 | 0.2% |
| http://www.thehungergames.movie | 4 | 0.2% |
| http://www.thehobbit.com | 3 | 0.2% |
| http://www.kungfupanda.com | 3 | 0.2% |
| http://www.lordoftherings.net | 3 | 0.2% |
| http://disney.go.com/disneypictures/pirates | 2 | 0.1% |
| http://www.teenagemutantninjaturtlesmovie.com | 2 | 0.1% |
| http://www.atlasshruggedmovie.com | 2 | 0.1% |
| http://www.twilightthemovie.com | 2 | 0.1% |
| Other values (1675) | 1683 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 5707 | 9.2% |
| / | 5701 | 9.1% |
| e | 4467 | 7.2% |
| o | 4438 | 7.1% |
| w | 4418 | 7.1% |
| m | 3492 | 5.6% |
| . | 3393 | 5.4% |
| h | 3110 | 5.0% |
| i | 3017 | 4.8% |
| c | 2543 | 4.1% |
| Other values (68) | 22065 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 62351 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 5707 | 9.2% |
| / | 5701 | 9.1% |
| e | 4467 | 7.2% |
| o | 4438 | 7.1% |
| w | 4418 | 7.1% |
| m | 3492 | 5.6% |
| . | 3393 | 5.4% |
| h | 3110 | 5.0% |
| i | 3017 | 4.8% |
| c | 2543 | 4.1% |
| Other values (68) | 22065 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 62351 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 5707 | 9.2% |
| / | 5701 | 9.1% |
| e | 4467 | 7.2% |
| o | 4438 | 7.1% |
| w | 4418 | 7.1% |
| m | 3492 | 5.6% |
| . | 3393 | 5.4% |
| h | 3110 | 5.0% |
| i | 3017 | 4.8% |
| c | 2543 | 4.1% |
| Other values (68) | 22065 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 62351 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 5707 | 9.2% |
| / | 5701 | 9.1% |
| e | 4467 | 7.2% |
| o | 4438 | 7.1% |
| w | 4418 | 7.1% |
| m | 3492 | 5.6% |
| . | 3393 | 5.4% |
| h | 3110 | 5.0% |
| i | 3017 | 4.8% |
| c | 2543 | 4.1% |
| Other values (68) | 22065 |
id
Real number (ℝ)
Unique
| Distinct | 4803 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57165.484 |
| Minimum | 5 |
|---|---|
| Maximum | 459488 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 578.1 |
| Q1 | 9014.5 |
| median | 14629 |
| Q3 | 58610.5 |
| 95-th percentile | 285779 |
| Maximum | 459488 |
| Range | 459483 |
| Interquartile range (IQR) | 49596 |
Descriptive statistics
| Standard deviation | 88694.614 |
|---|---|
| Coefficient of variation (CV) | 1.5515414 |
| Kurtosis | 3.3467477 |
| Mean | 57165.484 |
| Median Absolute Deviation (MAD) | 12920 |
| Skewness | 2.0720805 |
| Sum | 2.7456582 × 108 |
| Variance | 7.8667346 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19995 | 1 | < 0.1% |
| 333355 | 1 | < 0.1% |
| 71157 | 1 | < 0.1% |
| 43418 | 1 | < 0.1% |
| 11588 | 1 | < 0.1% |
| 52010 | 1 | < 0.1% |
| 9671 | 1 | < 0.1% |
| 25968 | 1 | < 0.1% |
| 41248 | 1 | < 0.1% |
| 291081 | 1 | < 0.1% |
| Other values (4793) | 4793 |
| Value | Count | Frequency (%) |
| 5 | 1 | |
| 11 | 1 | |
| 12 | 1 | |
| 13 | 1 | |
| 14 | 1 | |
| 16 | 1 | |
| 18 | 1 | |
| 19 | 1 | |
| 20 | 1 | |
| 22 | 1 |
| Value | Count | Frequency (%) |
| 459488 | 1 | |
| 447027 | 1 | |
| 433715 | 1 | |
| 426469 | 1 | |
| 426067 | 1 | |
| 417859 | 1 | |
| 408429 | 1 | |
| 407887 | 1 | |
| 402515 | 1 | |
| 396152 | 1 |
keywords
Text
| Distinct | 4222 |
|---|---|
| Distinct (%) | 87.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
Length
| Max length | 3783 |
|---|---|
| Median length | 749 |
| Mean length | 277.01145 |
| Min length | 2 |
Unique
| Unique | 4192 ? |
|---|---|
| Unique (%) | 87.3% |
Sample
| 1st row | [{"id": 1463, "name": "culture clash"}, {"id": 2964, "name": "future"}, {"id": 3386, "name": "space war"}, {"id": 3388, "name": "space colony"}, {"id": 3679, "name": "society"}, {"id": 3801, "name": "space travel"}, {"id": 9685, "name": "futuristic"}, {"id": 9840, "name": "romance"}, {"id": 9882, "name": "space"}, {"id": 9951, "name": "alien"}, {"id": 10148, "name": "tribe"}, {"id": 10158, "name": "alien planet"}, {"id": 10987, "name": "cgi"}, {"id": 11399, "name": "marine"}, {"id": 13065, "name": "soldier"}, {"id": 14643, "name": "battle"}, {"id": 14720, "name": "love affair"}, {"id": 165431, "name": "anti war"}, {"id": 193554, "name": "power relations"}, {"id": 206690, "name": "mind and soul"}, {"id": 209714, "name": "3d"}] |
|---|---|
| 2nd row | [{"id": 270, "name": "ocean"}, {"id": 726, "name": "drug abuse"}, {"id": 911, "name": "exotic island"}, {"id": 1319, "name": "east india trading company"}, {"id": 2038, "name": "love of one's life"}, {"id": 2052, "name": "traitor"}, {"id": 2580, "name": "shipwreck"}, {"id": 2660, "name": "strong woman"}, {"id": 3799, "name": "ship"}, {"id": 5740, "name": "alliance"}, {"id": 5941, "name": "calypso"}, {"id": 6155, "name": "afterlife"}, {"id": 6211, "name": "fighter"}, {"id": 12988, "name": "pirate"}, {"id": 157186, "name": "swashbuckler"}, {"id": 179430, "name": "aftercreditsstinger"}] |
| 3rd row | [{"id": 470, "name": "spy"}, {"id": 818, "name": "based on novel"}, {"id": 4289, "name": "secret agent"}, {"id": 9663, "name": "sequel"}, {"id": 14555, "name": "mi6"}, {"id": 156095, "name": "british secret service"}, {"id": 158431, "name": "united kingdom"}] |
| 4th row | [{"id": 849, "name": "dc comics"}, {"id": 853, "name": "crime fighter"}, {"id": 949, "name": "terrorist"}, {"id": 1308, "name": "secret identity"}, {"id": 1437, "name": "burglar"}, {"id": 3051, "name": "hostage drama"}, {"id": 3562, "name": "time bomb"}, {"id": 6969, "name": "gotham city"}, {"id": 7002, "name": "vigilante"}, {"id": 9665, "name": "cover-up"}, {"id": 9715, "name": "superhero"}, {"id": 9990, "name": "villainess"}, {"id": 10044, "name": "tragic hero"}, {"id": 13015, "name": "terrorism"}, {"id": 14796, "name": "destruction"}, {"id": 18933, "name": "catwoman"}, {"id": 156082, "name": "cat burglar"}, {"id": 156395, "name": "imax"}, {"id": 173272, "name": "flood"}, {"id": 179093, "name": "criminal underworld"}, {"id": 230775, "name": "batman"}] |
| 5th row | [{"id": 818, "name": "based on novel"}, {"id": 839, "name": "mars"}, {"id": 1456, "name": "medallion"}, {"id": 3801, "name": "space travel"}, {"id": 7376, "name": "princess"}, {"id": 9951, "name": "alien"}, {"id": 10028, "name": "steampunk"}, {"id": 10539, "name": "martian"}, {"id": 10685, "name": "escape"}, {"id": 161511, "name": "edgar rice burroughs"}, {"id": 163252, "name": "alien race"}, {"id": 179102, "name": "superhuman strength"}, {"id": 190320, "name": "mars civilization"}, {"id": 195446, "name": "sword and planet"}, {"id": 207928, "name": "19th century"}, {"id": 209714, "name": "3d"}] |
| Value | Count | Frequency (%) |
| id | 36196 | |
| name | 36195 | |
| of | 574 | 0.4% |
| on | 565 | 0.3% |
| relationship | 493 | 0.3% |
| based | 486 | 0.3% |
| film | 430 | 0.3% |
| 429 | 0.3% | |
| woman | 413 | 0.3% |
| love | 361 | 0.2% |
| Other values (17077) | 87393 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 217168 | |
| 158748 | 11.9% | |
| e | 74082 | 5.6% |
| : | 72388 | 5.4% |
| , | 68006 | 5.1% |
| i | 66211 | 5.0% |
| a | 65403 | 4.9% |
| n | 61324 | 4.6% |
| d | 49281 | 3.7% |
| m | 47096 | 3.5% |
| Other values (44) | 450779 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1330486 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 217168 | |
| 158748 | 11.9% | |
| e | 74082 | 5.6% |
| : | 72388 | 5.4% |
| , | 68006 | 5.1% |
| i | 66211 | 5.0% |
| a | 65403 | 4.9% |
| n | 61324 | 4.6% |
| d | 49281 | 3.7% |
| m | 47096 | 3.5% |
| Other values (44) | 450779 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1330486 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 217168 | |
| 158748 | 11.9% | |
| e | 74082 | 5.6% |
| : | 72388 | 5.4% |
| , | 68006 | 5.1% |
| i | 66211 | 5.0% |
| a | 65403 | 4.9% |
| n | 61324 | 4.6% |
| d | 49281 | 3.7% |
| m | 47096 | 3.5% |
| Other values (44) | 450779 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1330486 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 217168 | |
| 158748 | 11.9% | |
| e | 74082 | 5.6% |
| : | 72388 | 5.4% |
| , | 68006 | 5.1% |
| i | 66211 | 5.0% |
| a | 65403 | 4.9% |
| n | 61324 | 4.6% |
| d | 49281 | 3.7% |
| m | 47096 | 3.5% |
| Other values (44) | 450779 |
original_language
Categorical
Imbalance
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
| en | |
|---|---|
| fr | 70 |
| es | 32 |
| zh | 27 |
| de | 27 |
| Other values (32) | 142 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 14 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | en |
|---|---|
| 2nd row | en |
| 3rd row | en |
| 4th row | en |
| 5th row | en |
Common Values
| Value | Count | Frequency (%) |
| en | 4505 | |
| fr | 70 | 1.5% |
| es | 32 | 0.7% |
| zh | 27 | 0.6% |
| de | 27 | 0.6% |
| hi | 19 | 0.4% |
| ja | 16 | 0.3% |
| it | 14 | 0.3% |
| cn | 12 | 0.2% |
| ko | 11 | 0.2% |
| Other values (27) | 70 | 1.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| en | 4505 | |
| fr | 70 | 1.5% |
| es | 32 | 0.7% |
| zh | 27 | 0.6% |
| de | 27 | 0.6% |
| hi | 19 | 0.4% |
| ja | 16 | 0.3% |
| it | 14 | 0.3% |
| cn | 12 | 0.2% |
| ru | 11 | 0.2% |
| Other values (27) | 70 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4569 | |
| n | 4523 | |
| r | 86 | 0.9% |
| f | 75 | 0.8% |
| h | 53 | 0.6% |
| s | 42 | 0.4% |
| i | 37 | 0.4% |
| d | 36 | 0.4% |
| a | 32 | 0.3% |
| t | 30 | 0.3% |
| Other values (12) | 123 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9606 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 4569 | |
| n | 4523 | |
| r | 86 | 0.9% |
| f | 75 | 0.8% |
| h | 53 | 0.6% |
| s | 42 | 0.4% |
| i | 37 | 0.4% |
| d | 36 | 0.4% |
| a | 32 | 0.3% |
| t | 30 | 0.3% |
| Other values (12) | 123 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9606 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 4569 | |
| n | 4523 | |
| r | 86 | 0.9% |
| f | 75 | 0.8% |
| h | 53 | 0.6% |
| s | 42 | 0.4% |
| i | 37 | 0.4% |
| d | 36 | 0.4% |
| a | 32 | 0.3% |
| t | 30 | 0.3% |
| Other values (12) | 123 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9606 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 4569 | |
| n | 4523 | |
| r | 86 | 0.9% |
| f | 75 | 0.8% |
| h | 53 | 0.6% |
| s | 42 | 0.4% |
| i | 37 | 0.4% |
| d | 36 | 0.4% |
| a | 32 | 0.3% |
| t | 30 | 0.3% |
| Other values (12) | 123 | 1.3% |
original_title
Text
| Distinct | 4801 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
Length
| Max length | 86 |
|---|---|
| Median length | 59 |
| Mean length | 15.222986 |
| Min length | 1 |
Unique
| Unique | 4799 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | Avatar |
|---|---|
| 2nd row | Pirates of the Caribbean: At World's End |
| 3rd row | Spectre |
| 4th row | The Dark Knight Rises |
| 5th row | John Carter |
| Value | Count | Frequency (%) |
| the | 1420 | 10.7% |
| of | 432 | 3.3% |
| a | 168 | 1.3% |
| and | 127 | 1.0% |
| in | 110 | 0.8% |
| 2 | 102 | 0.8% |
| to | 102 | 0.8% |
| 80 | 0.6% | |
| man | 65 | 0.5% |
| love | 53 | 0.4% |
| Other values (5055) | 10578 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8436 | 11.5% | |
| e | 7412 | 10.1% |
| a | 4625 | 6.3% |
| o | 4370 | 6.0% |
| r | 3892 | 5.3% |
| n | 3885 | 5.3% |
| i | 3723 | 5.1% |
| t | 3600 | 4.9% |
| s | 2857 | 3.9% |
| h | 2717 | 3.7% |
| Other values (400) | 27599 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73116 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 8436 | 11.5% | |
| e | 7412 | 10.1% |
| a | 4625 | 6.3% |
| o | 4370 | 6.0% |
| r | 3892 | 5.3% |
| n | 3885 | 5.3% |
| i | 3723 | 5.1% |
| t | 3600 | 4.9% |
| s | 2857 | 3.9% |
| h | 2717 | 3.7% |
| Other values (400) | 27599 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73116 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 8436 | 11.5% | |
| e | 7412 | 10.1% |
| a | 4625 | 6.3% |
| o | 4370 | 6.0% |
| r | 3892 | 5.3% |
| n | 3885 | 5.3% |
| i | 3723 | 5.1% |
| t | 3600 | 4.9% |
| s | 2857 | 3.9% |
| h | 2717 | 3.7% |
| Other values (400) | 27599 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73116 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 8436 | 11.5% | |
| e | 7412 | 10.1% |
| a | 4625 | 6.3% |
| o | 4370 | 6.0% |
| r | 3892 | 5.3% |
| n | 3885 | 5.3% |
| i | 3723 | 5.1% |
| t | 3600 | 4.9% |
| s | 2857 | 3.9% |
| h | 2717 | 3.7% |
| Other values (400) | 27599 |
overview
Text
| Distinct | 4800 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 3 |
| Missing (%) | 0.1% |
| Memory size | 37.6 KiB |
Length
| Max length | 1000 |
|---|---|
| Median length | 625 |
| Mean length | 305.39875 |
| Min length | 1 |
Unique
| Unique | 4800 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | In the 22nd century, a paraplegic Marine is dispatched to the moon Pandora on a unique mission, but becomes torn between following orders and protecting an alien civilization. |
|---|---|
| 2nd row | Captain Barbossa, long believed to be dead, has come back to life and is headed to the edge of the Earth with Will Turner and Elizabeth Swann. But nothing is quite as it seems. |
| 3rd row | A cryptic message from Bond’s past sends him on a trail to uncover a sinister organization. While M battles political forces to keep the secret service alive, Bond peels back the layers of deceit to reveal the terrible truth behind SPECTRE. |
| 4th row | Following the death of District Attorney Harvey Dent, Batman assumes responsibility for Dent's crimes to protect the late attorney's reputation and is subsequently hunted by the Gotham City Police Department. Eight years later, Batman encounters the mysterious Selina Kyle and the villainous Bane, a new terrorist leader who overwhelms Gotham's finest. The Dark Knight resurfaces to protect a city that has branded him an enemy. |
| 5th row | John Carter is a war-weary, former military captain who's inexplicably transported to the mysterious and exotic planet of Barsoom (Mars) and reluctantly becomes embroiled in an epic conflict. It's a world on the brink of collapse, and Carter rediscovers his humanity when he realizes the survival of Barsoom and its people rests in his hands. |
| Value | Count | Frequency (%) |
| the | 13894 | 5.5% |
| a | 10452 | 4.2% |
| to | 7925 | 3.2% |
| and | 7388 | 3.0% |
| of | 6867 | 2.7% |
| in | 4536 | 1.8% |
| his | 3994 | 1.6% |
| is | 3369 | 1.3% |
| with | 2533 | 1.0% |
| her | 2163 | 0.9% |
| Other values (24224) | 187234 |
Most occurring characters
| Value | Count | Frequency (%) |
| 245712 | ||
| e | 141178 | 9.6% |
| t | 97104 | 6.6% |
| a | 94907 | 6.5% |
| i | 85329 | 5.8% |
| o | 84373 | 5.8% |
| n | 84015 | 5.7% |
| s | 78343 | 5.3% |
| r | 77154 | 5.3% |
| h | 61948 | 4.2% |
| Other values (117) | 415851 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1465914 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 245712 | ||
| e | 141178 | 9.6% |
| t | 97104 | 6.6% |
| a | 94907 | 6.5% |
| i | 85329 | 5.8% |
| o | 84373 | 5.8% |
| n | 84015 | 5.7% |
| s | 78343 | 5.3% |
| r | 77154 | 5.3% |
| h | 61948 | 4.2% |
| Other values (117) | 415851 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1465914 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 245712 | ||
| e | 141178 | 9.6% |
| t | 97104 | 6.6% |
| a | 94907 | 6.5% |
| i | 85329 | 5.8% |
| o | 84373 | 5.8% |
| n | 84015 | 5.7% |
| s | 78343 | 5.3% |
| r | 77154 | 5.3% |
| h | 61948 | 4.2% |
| Other values (117) | 415851 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1465914 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 245712 | ||
| e | 141178 | 9.6% |
| t | 97104 | 6.6% |
| a | 94907 | 6.5% |
| i | 85329 | 5.8% |
| o | 84373 | 5.8% |
| n | 84015 | 5.7% |
| s | 78343 | 5.3% |
| r | 77154 | 5.3% |
| h | 61948 | 4.2% |
| Other values (117) | 415851 |
popularity
Real number (ℝ)
High correlation
| Distinct | 4802 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.492301 |
| Minimum | 0 |
|---|---|
| Maximum | 875.58131 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.3628167 |
| Q1 | 4.66807 |
| median | 12.921594 |
| Q3 | 28.313505 |
| 95-th percentile | 67.385962 |
| Maximum | 875.58131 |
| Range | 875.58131 |
| Interquartile range (IQR) | 23.645435 |
Descriptive statistics
| Standard deviation | 31.81665 |
|---|---|
| Coefficient of variation (CV) | 1.4803743 |
| Kurtosis | 191.99582 |
| Mean | 21.492301 |
| Median Absolute Deviation (MAD) | 9.814445 |
| Skewness | 9.7214159 |
| Sum | 103227.52 |
| Variance | 1012.2992 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8.902102 | 2 | < 0.1% |
| 150.437577 | 1 | < 0.1% |
| 7.247023 | 1 | < 0.1% |
| 14.038703 | 1 | < 0.1% |
| 3.949796 | 1 | < 0.1% |
| 3.789485 | 1 | < 0.1% |
| 3.891186 | 1 | < 0.1% |
| 16.072466 | 1 | < 0.1% |
| 4.799022 | 1 | < 0.1% |
| 2.351706 | 1 | < 0.1% |
| Other values (4792) | 4792 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.000372 | 1 | |
| 0.001117 | 1 | |
| 0.001186 | 1 | |
| 0.001389 | 1 | |
| 0.001586 | 1 | |
| 0.002386 | 1 | |
| 0.002388 | 1 | |
| 0.003142 | 1 | |
| 0.003352 | 1 |
| Value | Count | Frequency (%) |
| 875.581305 | 1 | |
| 724.247784 | 1 | |
| 514.569956 | 1 | |
| 481.098624 | 1 | |
| 434.278564 | 1 | |
| 418.708552 | 1 | |
| 271.972889 | 1 | |
| 243.791743 | 1 | |
| 206.227151 | 1 | |
| 203.73459 | 1 |
| Distinct | 3697 |
|---|---|
| Distinct (%) | 77.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
Length
| Max length | 1155 |
|---|---|
| Median length | 469 |
| Mean length | 128.01499 |
| Min length | 2 |
Unique
| Unique | 3497 ? |
|---|---|
| Unique (%) | 72.8% |
Sample
| 1st row | [{"name": "Ingenious Film Partners", "id": 289}, {"name": "Twentieth Century Fox Film Corporation", "id": 306}, {"name": "Dune Entertainment", "id": 444}, {"name": "Lightstorm Entertainment", "id": 574}] |
|---|---|
| 2nd row | [{"name": "Walt Disney Pictures", "id": 2}, {"name": "Jerry Bruckheimer Films", "id": 130}, {"name": "Second Mate Productions", "id": 19936}] |
| 3rd row | [{"name": "Columbia Pictures", "id": 5}, {"name": "Danjaq", "id": 10761}, {"name": "B24", "id": 69434}] |
| 4th row | [{"name": "Legendary Pictures", "id": 923}, {"name": "Warner Bros.", "id": 6194}, {"name": "DC Entertainment", "id": 9993}, {"name": "Syncopy", "id": 9996}] |
| 5th row | [{"name": "Walt Disney Pictures", "id": 2}] |
| Value | Count | Frequency (%) |
| name | 13677 | 18.1% |
| id | 13677 | 18.1% |
| pictures | 2584 | 3.4% |
| films | 1883 | 2.5% |
| productions | 1830 | 2.4% |
| entertainment | 1567 | 2.1% |
| film | 915 | 1.2% |
| 538 | 0.7% | |
| corporation | 404 | 0.5% |
| fox | 372 | 0.5% |
| Other values (10124) | 38291 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 82064 | 13.3% |
| 70935 | 11.5% | |
| i | 34526 | 5.6% |
| e | 34198 | 5.6% |
| n | 32605 | 5.3% |
| a | 28315 | 4.6% |
| : | 27355 | 4.4% |
| , | 22976 | 3.7% |
| m | 22254 | 3.6% |
| d | 19878 | 3.2% |
| Other values (73) | 239750 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 614856 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 82064 | 13.3% |
| 70935 | 11.5% | |
| i | 34526 | 5.6% |
| e | 34198 | 5.6% |
| n | 32605 | 5.3% |
| a | 28315 | 4.6% |
| : | 27355 | 4.4% |
| , | 22976 | 3.7% |
| m | 22254 | 3.6% |
| d | 19878 | 3.2% |
| Other values (73) | 239750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 614856 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 82064 | 13.3% |
| 70935 | 11.5% | |
| i | 34526 | 5.6% |
| e | 34198 | 5.6% |
| n | 32605 | 5.3% |
| a | 28315 | 4.6% |
| : | 27355 | 4.4% |
| , | 22976 | 3.7% |
| m | 22254 | 3.6% |
| d | 19878 | 3.2% |
| Other values (73) | 239750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 614856 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 82064 | 13.3% |
| 70935 | 11.5% | |
| i | 34526 | 5.6% |
| e | 34198 | 5.6% |
| n | 32605 | 5.3% |
| a | 28315 | 4.6% |
| : | 27355 | 4.4% |
| , | 22976 | 3.7% |
| m | 22254 | 3.6% |
| d | 19878 | 3.2% |
| Other values (73) | 239750 |
| Distinct | 469 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
Length
| Max length | 517 |
|---|---|
| Median length | 58 |
| Mean length | 69.921299 |
| Min length | 2 |
Unique
| Unique | 353 ? |
|---|---|
| Unique (%) | 7.3% |
Sample
| 1st row | [{"iso_3166_1": "US", "name": "United States of America"}, {"iso_3166_1": "GB", "name": "United Kingdom"}] |
|---|---|
| 2nd row | [{"iso_3166_1": "US", "name": "United States of America"}] |
| 3rd row | [{"iso_3166_1": "GB", "name": "United Kingdom"}, {"iso_3166_1": "US", "name": "United States of America"}] |
| 4th row | [{"iso_3166_1": "US", "name": "United States of America"}] |
| 5th row | [{"iso_3166_1": "US", "name": "United States of America"}] |
| Value | Count | Frequency (%) |
| iso_3166_1 | 6436 | |
| name | 6436 | |
| united | 4606 | |
| of | 3956 | |
| america | 3956 | |
| us | 3956 | |
| states | 3956 | |
| kingdom | 636 | 1.6% |
| gb | 636 | 1.6% |
| de | 324 | 0.8% |
| Other values (180) | 3698 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 51488 | 15.3% |
| 33793 | 10.1% | |
| e | 19992 | 6.0% |
| a | 16820 | 5.0% |
| i | 16187 | 4.8% |
| n | 13165 | 3.9% |
| _ | 12872 | 3.8% |
| 1 | 12872 | 3.8% |
| 6 | 12872 | 3.8% |
| : | 12872 | 3.8% |
| Other values (51) | 132899 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 335832 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 51488 | 15.3% |
| 33793 | 10.1% | |
| e | 19992 | 6.0% |
| a | 16820 | 5.0% |
| i | 16187 | 4.8% |
| n | 13165 | 3.9% |
| _ | 12872 | 3.8% |
| 1 | 12872 | 3.8% |
| 6 | 12872 | 3.8% |
| : | 12872 | 3.8% |
| Other values (51) | 132899 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 335832 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 51488 | 15.3% |
| 33793 | 10.1% | |
| e | 19992 | 6.0% |
| a | 16820 | 5.0% |
| i | 16187 | 4.8% |
| n | 13165 | 3.9% |
| _ | 12872 | 3.8% |
| 1 | 12872 | 3.8% |
| 6 | 12872 | 3.8% |
| : | 12872 | 3.8% |
| Other values (51) | 132899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 335832 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 51488 | 15.3% |
| 33793 | 10.1% | |
| e | 19992 | 6.0% |
| a | 16820 | 5.0% |
| i | 16187 | 4.8% |
| n | 13165 | 3.9% |
| _ | 12872 | 3.8% |
| 1 | 12872 | 3.8% |
| 6 | 12872 | 3.8% |
| : | 12872 | 3.8% |
| Other values (51) | 132899 |
release_date
Date
| Distinct | 3280 |
|---|---|
| Distinct (%) | 68.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 37.6 KiB |
| Minimum | 1916-09-04 00:00:00 |
|---|---|
| Maximum | 2017-02-03 00:00:00 |
Histogram with fixed size bins (bins=50)
revenue
Real number (ℝ)
High correlation Zeros
| Distinct | 3297 |
|---|---|
| Distinct (%) | 68.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 82260639 |
| Minimum | 0 |
|---|---|
| Maximum | 2.7879651 × 109 |
| Zeros | 1427 |
| Zeros (%) | 29.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 19170001 |
| Q3 | 92917187 |
| 95-th percentile | 3.692849 × 108 |
| Maximum | 2.7879651 × 109 |
| Range | 2.7879651 × 109 |
| Interquartile range (IQR) | 92917187 |
Descriptive statistics
| Standard deviation | 1.628571 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.9797695 |
| Kurtosis | 33.12363 |
| Mean | 82260639 |
| Median Absolute Deviation (MAD) | 19170001 |
| Skewness | 4.4447164 |
| Sum | 3.9509785 × 1011 |
| Variance | 2.6522435 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1427 | |
| 7000000 | 6 | 0.1% |
| 8000000 | 6 | 0.1% |
| 6000000 | 5 | 0.1% |
| 12000000 | 5 | 0.1% |
| 10000000 | 5 | 0.1% |
| 100000000 | 5 | 0.1% |
| 14000000 | 4 | 0.1% |
| 11000000 | 4 | 0.1% |
| 5000000 | 4 | 0.1% |
| Other values (3287) | 3332 |
| Value | Count | Frequency (%) |
| 0 | 1427 | |
| 5 | 1 | < 0.1% |
| 7 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 12 | 2 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 16 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2787965087 | 1 | |
| 1845034188 | 1 | |
| 1519557910 | 1 | |
| 1513528810 | 1 | |
| 1506249360 | 1 | |
| 1405403694 | 1 | |
| 1274219009 | 1 | |
| 1215439994 | 1 | |
| 1156730962 | 1 | |
| 1153304495 | 1 |
runtime
Real number (ℝ)
| Distinct | 156 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 106.87586 |
| Minimum | 0 |
|---|---|
| Maximum | 338 |
| Zeros | 35 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 83 |
| Q1 | 94 |
| median | 103 |
| Q3 | 118 |
| 95-th percentile | 144 |
| Maximum | 338 |
| Range | 338 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 22.611935 |
|---|---|
| Coefficient of variation (CV) | 0.21157196 |
| Kurtosis | 8.9354488 |
| Mean | 106.87586 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.71595651 |
| Sum | 513111 |
| Variance | 511.29959 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 90 | 163 | 3.4% |
| 100 | 149 | 3.1% |
| 98 | 140 | 2.9% |
| 97 | 133 | 2.8% |
| 95 | 123 | 2.6% |
| 99 | 119 | 2.5% |
| 94 | 116 | 2.4% |
| 96 | 115 | 2.4% |
| 101 | 114 | 2.4% |
| 93 | 113 | 2.4% |
| Other values (146) | 3516 |
| Value | Count | Frequency (%) |
| 0 | 35 | |
| 14 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 46 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 53 | 1 | < 0.1% |
| 59 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 338 | 1 | |
| 276 | 1 | |
| 254 | 1 | |
| 248 | 1 | |
| 242 | 1 | |
| 240 | 1 | |
| 238 | 1 | |
| 229 | 1 | |
| 225 | 1 | |
| 219 | 1 |
spoken_languages
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
status
Categorical
Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
| Released | |
|---|---|
| Rumored | 5 |
| Post Production | 3 |
Length
| Max length | 15 |
|---|---|
| Median length | 8 |
| Mean length | 8.0033313 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Released |
|---|---|
| 2nd row | Released |
| 3rd row | Released |
| 4th row | Released |
| 5th row | Released |
Common Values
| Value | Count | Frequency (%) |
| Released | 4795 | |
| Rumored | 5 | 0.1% |
| Post Production | 3 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| released | 4795 | |
| rumored | 5 | 0.1% |
| post | 3 | 0.1% |
| production | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 14390 | |
| d | 4803 | 12.5% |
| R | 4800 | 12.5% |
| s | 4798 | 12.5% |
| l | 4795 | 12.5% |
| a | 4795 | 12.5% |
| o | 14 | < 0.1% |
| u | 8 | < 0.1% |
| r | 8 | < 0.1% |
| P | 6 | < 0.1% |
| Other values (6) | 23 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 38440 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 14390 | |
| d | 4803 | 12.5% |
| R | 4800 | 12.5% |
| s | 4798 | 12.5% |
| l | 4795 | 12.5% |
| a | 4795 | 12.5% |
| o | 14 | < 0.1% |
| u | 8 | < 0.1% |
| r | 8 | < 0.1% |
| P | 6 | < 0.1% |
| Other values (6) | 23 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 38440 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 14390 | |
| d | 4803 | 12.5% |
| R | 4800 | 12.5% |
| s | 4798 | 12.5% |
| l | 4795 | 12.5% |
| a | 4795 | 12.5% |
| o | 14 | < 0.1% |
| u | 8 | < 0.1% |
| r | 8 | < 0.1% |
| P | 6 | < 0.1% |
| Other values (6) | 23 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 38440 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 14390 | |
| d | 4803 | 12.5% |
| R | 4800 | 12.5% |
| s | 4798 | 12.5% |
| l | 4795 | 12.5% |
| a | 4795 | 12.5% |
| o | 14 | < 0.1% |
| u | 8 | < 0.1% |
| r | 8 | < 0.1% |
| P | 6 | < 0.1% |
| Other values (6) | 23 | 0.1% |
tagline
Text
Missing
| Distinct | 3944 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 844 |
| Missing (%) | 17.6% |
| Memory size | 37.6 KiB |
Length
| Max length | 252 |
|---|---|
| Median length | 149 |
| Mean length | 41.988886 |
| Min length | 3 |
Unique
| Unique | 3930 ? |
|---|---|
| Unique (%) | 99.3% |
Sample
| 1st row | Enter the World of Pandora. |
|---|---|
| 2nd row | At the end of the world, the adventure begins. |
| 3rd row | A Plan No One Escapes |
| 4th row | The Legend Ends |
| 5th row | Lost in our world, found in another. |
| Value | Count | Frequency (%) |
| the | 1880 | 6.1% |
| a | 1085 | 3.5% |
| to | 705 | 2.3% |
| is | 653 | 2.1% |
| of | 620 | 2.0% |
| you | 535 | 1.7% |
| in | 443 | 1.4% |
| and | 328 | 1.1% |
| for | 323 | 1.0% |
| it | 310 | 1.0% |
| Other values (4349) | 23980 |
Most occurring characters
| Value | Count | Frequency (%) |
| 26926 | ||
| e | 17450 | 10.5% |
| o | 10463 | 6.3% |
| t | 10358 | 6.2% |
| a | 8761 | 5.3% |
| n | 8406 | 5.1% |
| i | 8137 | 4.9% |
| r | 7933 | 4.8% |
| s | 7648 | 4.6% |
| h | 6587 | 4.0% |
| Other values (82) | 53565 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 166234 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 26926 | ||
| e | 17450 | 10.5% |
| o | 10463 | 6.3% |
| t | 10358 | 6.2% |
| a | 8761 | 5.3% |
| n | 8406 | 5.1% |
| i | 8137 | 4.9% |
| r | 7933 | 4.8% |
| s | 7648 | 4.6% |
| h | 6587 | 4.0% |
| Other values (82) | 53565 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 166234 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 26926 | ||
| e | 17450 | 10.5% |
| o | 10463 | 6.3% |
| t | 10358 | 6.2% |
| a | 8761 | 5.3% |
| n | 8406 | 5.1% |
| i | 8137 | 4.9% |
| r | 7933 | 4.8% |
| s | 7648 | 4.6% |
| h | 6587 | 4.0% |
| Other values (82) | 53565 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 166234 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 26926 | ||
| e | 17450 | 10.5% |
| o | 10463 | 6.3% |
| t | 10358 | 6.2% |
| a | 8761 | 5.3% |
| n | 8406 | 5.1% |
| i | 8137 | 4.9% |
| r | 7933 | 4.8% |
| s | 7648 | 4.6% |
| h | 6587 | 4.0% |
| Other values (82) | 53565 |
title
Text
| Distinct | 4800 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
Length
| Max length | 86 |
|---|---|
| Median length | 58 |
| Mean length | 15.349157 |
| Min length | 1 |
Unique
| Unique | 4797 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | Avatar |
|---|---|
| 2nd row | Pirates of the Caribbean: At World's End |
| 3rd row | Spectre |
| 4th row | The Dark Knight Rises |
| 5th row | John Carter |
| Value | Count | Frequency (%) |
| the | 1526 | 11.4% |
| of | 474 | 3.5% |
| a | 180 | 1.3% |
| and | 139 | 1.0% |
| in | 116 | 0.9% |
| to | 107 | 0.8% |
| 2 | 103 | 0.8% |
| 79 | 0.6% | |
| man | 66 | 0.5% |
| love | 56 | 0.4% |
| Other values (4810) | 10508 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8553 | 11.6% | |
| e | 7525 | 10.2% |
| a | 4632 | 6.3% |
| o | 4470 | 6.1% |
| n | 3950 | 5.4% |
| r | 3946 | 5.4% |
| i | 3765 | 5.1% |
| t | 3660 | 5.0% |
| s | 2862 | 3.9% |
| h | 2852 | 3.9% |
| Other values (88) | 27507 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73722 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 8553 | 11.6% | |
| e | 7525 | 10.2% |
| a | 4632 | 6.3% |
| o | 4470 | 6.1% |
| n | 3950 | 5.4% |
| r | 3946 | 5.4% |
| i | 3765 | 5.1% |
| t | 3660 | 5.0% |
| s | 2862 | 3.9% |
| h | 2852 | 3.9% |
| Other values (88) | 27507 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73722 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 8553 | 11.6% | |
| e | 7525 | 10.2% |
| a | 4632 | 6.3% |
| o | 4470 | 6.1% |
| n | 3950 | 5.4% |
| r | 3946 | 5.4% |
| i | 3765 | 5.1% |
| t | 3660 | 5.0% |
| s | 2862 | 3.9% |
| h | 2852 | 3.9% |
| Other values (88) | 27507 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73722 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 8553 | 11.6% | |
| e | 7525 | 10.2% |
| a | 4632 | 6.3% |
| o | 4470 | 6.1% |
| n | 3950 | 5.4% |
| r | 3946 | 5.4% |
| i | 3765 | 5.1% |
| t | 3660 | 5.0% |
| s | 2862 | 3.9% |
| h | 2852 | 3.9% |
| Other values (88) | 27507 |
vote_average
Real number (ℝ)
High correlation Zeros
| Distinct | 71 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.0921716 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 63 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.3 |
| Q1 | 5.6 |
| median | 6.2 |
| Q3 | 6.8 |
| 95-th percentile | 7.6 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 1.2 |
Descriptive statistics
| Standard deviation | 1.1946122 |
|---|---|
| Coefficient of variation (CV) | 0.19608971 |
| Kurtosis | 7.7923628 |
| Mean | 6.0921716 |
| Median Absolute Deviation (MAD) | 0.6 |
| Skewness | -1.95971 |
| Sum | 29260.7 |
| Variance | 1.4270982 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6.5 | 216 | 4.5% |
| 6 | 216 | 4.5% |
| 6.7 | 213 | 4.4% |
| 6.3 | 207 | 4.3% |
| 6.1 | 201 | 4.2% |
| 6.4 | 201 | 4.2% |
| 6.2 | 200 | 4.2% |
| 6.6 | 198 | 4.1% |
| 5.9 | 196 | 4.1% |
| 5.8 | 187 | 3.9% |
| Other values (61) | 2768 |
| Value | Count | Frequency (%) |
| 0 | 63 | |
| 0.5 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 1.9 | 1 | < 0.1% |
| 2 | 6 | 0.1% |
| 2.2 | 1 | < 0.1% |
| 2.3 | 2 | < 0.1% |
| 2.4 | 1 | < 0.1% |
| 2.6 | 1 | < 0.1% |
| 2.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 4 | 0.1% |
| 9.5 | 1 | < 0.1% |
| 9.3 | 1 | < 0.1% |
| 8.5 | 2 | < 0.1% |
| 8.4 | 2 | < 0.1% |
| 8.3 | 7 | 0.1% |
| 8.2 | 15 | |
| 8.1 | 18 | |
| 8 | 35 | |
| 7.9 | 32 |
vote_count
Real number (ℝ)
High correlation Zeros
| Distinct | 1609 |
|---|---|
| Distinct (%) | 33.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 690.21799 |
| Minimum | 0 |
|---|---|
| Maximum | 13752 |
| Zeros | 62 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 54 |
| median | 235 |
| Q3 | 737 |
| 95-th percentile | 3040.9 |
| Maximum | 13752 |
| Range | 13752 |
| Interquartile range (IQR) | 683 |
Descriptive statistics
| Standard deviation | 1234.5859 |
|---|---|
| Coefficient of variation (CV) | 1.7886898 |
| Kurtosis | 19.913946 |
| Mean | 690.21799 |
| Median Absolute Deviation (MAD) | 214 |
| Skewness | 3.8240685 |
| Sum | 3315117 |
| Variance | 1524202.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 62 | 1.3% |
| 1 | 53 | 1.1% |
| 2 | 46 | 1.0% |
| 4 | 43 | 0.9% |
| 3 | 41 | 0.9% |
| 6 | 38 | 0.8% |
| 8 | 37 | 0.8% |
| 10 | 34 | 0.7% |
| 11 | 32 | 0.7% |
| 9 | 32 | 0.7% |
| Other values (1599) | 4385 |
| Value | Count | Frequency (%) |
| 0 | 62 | |
| 1 | 53 | |
| 2 | 46 | |
| 3 | 41 | |
| 4 | 43 | |
| 5 | 28 | |
| 6 | 38 | |
| 7 | 31 | |
| 8 | 37 | |
| 9 | 32 |
| Value | Count | Frequency (%) |
| 13752 | 1 | |
| 12002 | 1 | |
| 11800 | 1 | |
| 11776 | 1 | |
| 10995 | 1 | |
| 10867 | 1 | |
| 10099 | 1 | |
| 9742 | 1 | |
| 9455 | 1 | |
| 9427 | 1 |
vote_average_scaled
Real number (ℝ)
High correlation Zeros
| Distinct | 71 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.60921716 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 63 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.43 |
| Q1 | 0.56 |
| median | 0.62 |
| Q3 | 0.68 |
| 95-th percentile | 0.76 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.12 |
Descriptive statistics
| Standard deviation | 0.11946122 |
|---|---|
| Coefficient of variation (CV) | 0.19608971 |
| Kurtosis | 7.7923628 |
| Mean | 0.60921716 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | -1.95971 |
| Sum | 2926.07 |
| Variance | 0.014270982 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.65 | 216 | 4.5% |
| 0.6 | 216 | 4.5% |
| 0.67 | 213 | 4.4% |
| 0.63 | 207 | 4.3% |
| 0.61 | 201 | 4.2% |
| 0.64 | 201 | 4.2% |
| 0.62 | 200 | 4.2% |
| 0.66 | 198 | 4.1% |
| 0.59 | 196 | 4.1% |
| 0.58 | 187 | 3.9% |
| Other values (61) | 2768 |
| Value | Count | Frequency (%) |
| 0 | 63 | |
| 0.05 | 1 | < 0.1% |
| 0.1 | 2 | < 0.1% |
| 0.19 | 1 | < 0.1% |
| 0.2 | 6 | 0.1% |
| 0.22 | 1 | < 0.1% |
| 0.23 | 2 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 0.26 | 1 | < 0.1% |
| 0.27 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4 | 0.1% |
| 0.95 | 1 | < 0.1% |
| 0.93 | 1 | < 0.1% |
| 0.85 | 2 | < 0.1% |
| 0.84 | 2 | < 0.1% |
| 0.83 | 7 | 0.1% |
| 0.82 | 15 | |
| 0.81 | 18 | |
| 0.8 | 35 | |
| 0.79 | 32 |
popularity_scaled
Real number (ℝ)
High correlation
| Distinct | 4802 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.024546322 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.00041437237 |
| Q1 | 0.0053313952 |
| median | 0.014757732 |
| Q3 | 0.032336808 |
| 95-th percentile | 0.076961399 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.027005413 |
Descriptive statistics
| Standard deviation | 0.036337744 |
|---|---|
| Coefficient of variation (CV) | 1.4803743 |
| Kurtosis | 191.99582 |
| Mean | 0.024546322 |
| Median Absolute Deviation (MAD) | 0.011209062 |
| Skewness | 9.7214159 |
| Sum | 117.89598 |
| Variance | 0.0013204317 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.01016707637 | 2 | < 0.1% |
| 0.1718145147 | 1 | < 0.1% |
| 0.008276813311 | 1 | < 0.1% |
| 0.01603358011 | 1 | < 0.1% |
| 0.004511055658 | 1 | < 0.1% |
| 0.004327964723 | 1 | < 0.1% |
| 0.004444117271 | 1 | < 0.1% |
| 0.01835633756 | 1 | < 0.1% |
| 0.005480955307 | 1 | < 0.1% |
| 0.00268587964 | 1 | < 0.1% |
| Other values (4792) | 4792 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 4.248606016 × 10-7 | 1 | |
| 1.275723903 × 10-6 | 1 | |
| 1.354528692 × 10-6 | 1 | |
| 1.586374666 × 10-6 | 1 | |
| 1.811368049 × 10-6 | 1 | |
| 2.725046762 × 10-6 | 1 | |
| 2.727330959 × 10-6 | 1 | |
| 3.588473146 × 10-6 | 1 | |
| 3.828313808 × 10-6 | 1 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 0.8271622291 | 1 | |
| 0.587689519 | 1 | |
| 0.5494619646 | 1 | |
| 0.4959888494 | 1 | |
| 0.4782063637 | 1 | |
| 0.310619799 | 1 | |
| 0.2784341575 | 1 | |
| 0.2355316974 | 1 | |
| 0.2326849475 | 1 |
label
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.6 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2555 | |
| 0 | 2248 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2555 | |
| 0 | 2248 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2555 | |
| 0 | 2248 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4803 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2555 | |
| 0 | 2248 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4803 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2555 | |
| 0 | 2248 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4803 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2555 | |
| 0 | 2248 |
Interactions
Correlations
| budget | id | label | original_language | popularity | popularity_scaled | revenue | runtime | status | vote_average | vote_average_scaled | vote_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| budget | 1.000 | -0.246 | 0.050 | 0.000 | 0.649 | 0.649 | 0.757 | 0.326 | 0.000 | 0.066 | 0.066 | 0.663 |
| id | -0.246 | 1.000 | 0.112 | 0.089 | -0.278 | -0.278 | -0.292 | -0.216 | 0.048 | -0.266 | -0.266 | -0.297 |
| label | 0.050 | 0.112 | 1.000 | 0.089 | 0.099 | 0.099 | 0.140 | 0.305 | 0.000 | 0.921 | 0.921 | 0.238 |
| original_language | 0.000 | 0.089 | 0.089 | 1.000 | 0.000 | 0.000 | 0.000 | 0.020 | 0.275 | 0.059 | 0.059 | 0.000 |
| popularity | 0.649 | -0.278 | 0.099 | 0.000 | 1.000 | 1.000 | 0.777 | 0.302 | 0.000 | 0.359 | 0.359 | 0.960 |
| popularity_scaled | 0.649 | -0.278 | 0.099 | 0.000 | 1.000 | 1.000 | 0.777 | 0.302 | 0.000 | 0.359 | 0.359 | 0.960 |
| revenue | 0.757 | -0.292 | 0.140 | 0.000 | 0.777 | 0.777 | 1.000 | 0.317 | 0.000 | 0.243 | 0.243 | 0.804 |
| runtime | 0.326 | -0.216 | 0.305 | 0.020 | 0.302 | 0.302 | 0.317 | 1.000 | 0.029 | 0.398 | 0.398 | 0.304 |
| status | 0.000 | 0.048 | 0.000 | 0.275 | 0.000 | 0.000 | 0.000 | 0.029 | 1.000 | 0.131 | 0.131 | 0.000 |
| vote_average | 0.066 | -0.266 | 0.921 | 0.059 | 0.359 | 0.359 | 0.243 | 0.398 | 0.131 | 1.000 | 1.000 | 0.381 |
| vote_average_scaled | 0.066 | -0.266 | 0.921 | 0.059 | 0.359 | 0.359 | 0.243 | 0.398 | 0.131 | 1.000 | 1.000 | 0.381 |
| vote_count | 0.663 | -0.297 | 0.238 | 0.000 | 0.960 | 0.960 | 0.804 | 0.304 | 0.000 | 0.381 | 0.381 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| budget | genres | homepage | id | keywords | original_language | original_title | overview | popularity | production_companies | production_countries | release_date | revenue | runtime | spoken_languages | status | tagline | title | vote_average | vote_count | vote_average_scaled | popularity_scaled | label | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 237000000 | [Action, Adventure, Fantasy, Science Fiction] | http://www.avatarmovie.com/ | 19995 | [{"id": 1463, "name": "culture clash"}, {"id": 2964, "name": "future"}, {"id": 3386, "name": "space war"}, {"id": 3388, "name": "space colony"}, {"id": 3679, "name": "society"}, {"id": 3801, "name": "space travel"}, {"id": 9685, "name": "futuristic"}, {"id": 9840, "name": "romance"}, {"id": 9882, "name": "space"}, {"id": 9951, "name": "alien"}, {"id": 10148, "name": "tribe"}, {"id": 10158, "name": "alien planet"}, {"id": 10987, "name": "cgi"}, {"id": 11399, "name": "marine"}, {"id": 13065, "name": "soldier"}, {"id": 14643, "name": "battle"}, {"id": 14720, "name": "love affair"}, {"id": 165431, "name": "anti war"}, {"id": 193554, "name": "power relations"}, {"id": 206690, "name": "mind and soul"}, {"id": 209714, "name": "3d"}] | en | Avatar | In the 22nd century, a paraplegic Marine is dispatched to the moon Pandora on a unique mission, but becomes torn between following orders and protecting an alien civilization. | 150.437577 | [{"name": "Ingenious Film Partners", "id": 289}, {"name": "Twentieth Century Fox Film Corporation", "id": 306}, {"name": "Dune Entertainment", "id": 444}, {"name": "Lightstorm Entertainment", "id": 574}] | [{"iso_3166_1": "US", "name": "United States of America"}, {"iso_3166_1": "GB", "name": "United Kingdom"}] | 2009-12-10 | 2787965087 | 162.0 | [English, Español] | Released | Enter the World of Pandora. | Avatar | 7.2 | 11800 | 0.72 | 0.171815 | 1 |
| 1 | 300000000 | [Adventure, Fantasy, Action] | http://disney.go.com/disneypictures/pirates/ | 285 | [{"id": 270, "name": "ocean"}, {"id": 726, "name": "drug abuse"}, {"id": 911, "name": "exotic island"}, {"id": 1319, "name": "east india trading company"}, {"id": 2038, "name": "love of one's life"}, {"id": 2052, "name": "traitor"}, {"id": 2580, "name": "shipwreck"}, {"id": 2660, "name": "strong woman"}, {"id": 3799, "name": "ship"}, {"id": 5740, "name": "alliance"}, {"id": 5941, "name": "calypso"}, {"id": 6155, "name": "afterlife"}, {"id": 6211, "name": "fighter"}, {"id": 12988, "name": "pirate"}, {"id": 157186, "name": "swashbuckler"}, {"id": 179430, "name": "aftercreditsstinger"}] | en | Pirates of the Caribbean: At World's End | Captain Barbossa, long believed to be dead, has come back to life and is headed to the edge of the Earth with Will Turner and Elizabeth Swann. But nothing is quite as it seems. | 139.082615 | [{"name": "Walt Disney Pictures", "id": 2}, {"name": "Jerry Bruckheimer Films", "id": 130}, {"name": "Second Mate Productions", "id": 19936}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2007-05-19 | 961000000 | 169.0 | [English] | Released | At the end of the world, the adventure begins. | Pirates of the Caribbean: At World's End | 6.9 | 4500 | 0.69 | 0.158846 | 1 |
| 2 | 245000000 | [Action, Adventure, Crime] | http://www.sonypictures.com/movies/spectre/ | 206647 | [{"id": 470, "name": "spy"}, {"id": 818, "name": "based on novel"}, {"id": 4289, "name": "secret agent"}, {"id": 9663, "name": "sequel"}, {"id": 14555, "name": "mi6"}, {"id": 156095, "name": "british secret service"}, {"id": 158431, "name": "united kingdom"}] | en | Spectre | A cryptic message from Bond’s past sends him on a trail to uncover a sinister organization. While M battles political forces to keep the secret service alive, Bond peels back the layers of deceit to reveal the terrible truth behind SPECTRE. | 107.376788 | [{"name": "Columbia Pictures", "id": 5}, {"name": "Danjaq", "id": 10761}, {"name": "B24", "id": 69434}] | [{"iso_3166_1": "GB", "name": "United Kingdom"}, {"iso_3166_1": "US", "name": "United States of America"}] | 2015-10-26 | 880674609 | 148.0 | [Français, English, Español, Italiano, Deutsch] | Released | A Plan No One Escapes | Spectre | 6.3 | 4466 | 0.63 | 0.122635 | 1 |
| 3 | 250000000 | [Action, Crime, Drama, Thriller] | http://www.thedarkknightrises.com/ | 49026 | [{"id": 849, "name": "dc comics"}, {"id": 853, "name": "crime fighter"}, {"id": 949, "name": "terrorist"}, {"id": 1308, "name": "secret identity"}, {"id": 1437, "name": "burglar"}, {"id": 3051, "name": "hostage drama"}, {"id": 3562, "name": "time bomb"}, {"id": 6969, "name": "gotham city"}, {"id": 7002, "name": "vigilante"}, {"id": 9665, "name": "cover-up"}, {"id": 9715, "name": "superhero"}, {"id": 9990, "name": "villainess"}, {"id": 10044, "name": "tragic hero"}, {"id": 13015, "name": "terrorism"}, {"id": 14796, "name": "destruction"}, {"id": 18933, "name": "catwoman"}, {"id": 156082, "name": "cat burglar"}, {"id": 156395, "name": "imax"}, {"id": 173272, "name": "flood"}, {"id": 179093, "name": "criminal underworld"}, {"id": 230775, "name": "batman"}] | en | The Dark Knight Rises | Following the death of District Attorney Harvey Dent, Batman assumes responsibility for Dent's crimes to protect the late attorney's reputation and is subsequently hunted by the Gotham City Police Department. Eight years later, Batman encounters the mysterious Selina Kyle and the villainous Bane, a new terrorist leader who overwhelms Gotham's finest. The Dark Knight resurfaces to protect a city that has branded him an enemy. | 112.312950 | [{"name": "Legendary Pictures", "id": 923}, {"name": "Warner Bros.", "id": 6194}, {"name": "DC Entertainment", "id": 9993}, {"name": "Syncopy", "id": 9996}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2012-07-16 | 1084939099 | 165.0 | [English] | Released | The Legend Ends | The Dark Knight Rises | 7.6 | 9106 | 0.76 | 0.128272 | 1 |
| 4 | 260000000 | [Action, Adventure, Science Fiction] | http://movies.disney.com/john-carter | 49529 | [{"id": 818, "name": "based on novel"}, {"id": 839, "name": "mars"}, {"id": 1456, "name": "medallion"}, {"id": 3801, "name": "space travel"}, {"id": 7376, "name": "princess"}, {"id": 9951, "name": "alien"}, {"id": 10028, "name": "steampunk"}, {"id": 10539, "name": "martian"}, {"id": 10685, "name": "escape"}, {"id": 161511, "name": "edgar rice burroughs"}, {"id": 163252, "name": "alien race"}, {"id": 179102, "name": "superhuman strength"}, {"id": 190320, "name": "mars civilization"}, {"id": 195446, "name": "sword and planet"}, {"id": 207928, "name": "19th century"}, {"id": 209714, "name": "3d"}] | en | John Carter | John Carter is a war-weary, former military captain who's inexplicably transported to the mysterious and exotic planet of Barsoom (Mars) and reluctantly becomes embroiled in an epic conflict. It's a world on the brink of collapse, and Carter rediscovers his humanity when he realizes the survival of Barsoom and its people rests in his hands. | 43.926995 | [{"name": "Walt Disney Pictures", "id": 2}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2012-03-07 | 284139100 | 132.0 | [English] | Released | Lost in our world, found in another. | John Carter | 6.1 | 2124 | 0.61 | 0.050169 | 0 |
| 5 | 258000000 | [Fantasy, Action, Adventure] | http://www.sonypictures.com/movies/spider-man3/ | 559 | [{"id": 851, "name": "dual identity"}, {"id": 1453, "name": "amnesia"}, {"id": 1965, "name": "sandstorm"}, {"id": 2038, "name": "love of one's life"}, {"id": 3446, "name": "forgiveness"}, {"id": 3986, "name": "spider"}, {"id": 4391, "name": "wretch"}, {"id": 4959, "name": "death of a friend"}, {"id": 5776, "name": "egomania"}, {"id": 5789, "name": "sand"}, {"id": 5857, "name": "narcism"}, {"id": 6062, "name": "hostility"}, {"id": 8828, "name": "marvel comic"}, {"id": 9663, "name": "sequel"}, {"id": 9715, "name": "superhero"}, {"id": 9748, "name": "revenge"}] | en | Spider-Man 3 | The seemingly invincible Spider-Man goes up against an all-new crop of villain – including the shape-shifting Sandman. While Spider-Man’s superpowers are altered by an alien organism, his alter ego, Peter Parker, deals with nemesis Eddie Brock and also gets caught up in a love triangle. | 115.699814 | [{"name": "Columbia Pictures", "id": 5}, {"name": "Laura Ziskin Productions", "id": 326}, {"name": "Marvel Enterprises", "id": 19551}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2007-05-01 | 890871626 | 139.0 | [English, Français] | Released | The battle within. | Spider-Man 3 | 5.9 | 3576 | 0.59 | 0.132141 | 0 |
| 6 | 260000000 | [Animation, Family] | http://disney.go.com/disneypictures/tangled/ | 38757 | [{"id": 1562, "name": "hostage"}, {"id": 2343, "name": "magic"}, {"id": 2673, "name": "horse"}, {"id": 3205, "name": "fairy tale"}, {"id": 4344, "name": "musical"}, {"id": 7376, "name": "princess"}, {"id": 10336, "name": "animation"}, {"id": 33787, "name": "tower"}, {"id": 155658, "name": "blonde woman"}, {"id": 162219, "name": "selfishness"}, {"id": 163545, "name": "healing power"}, {"id": 179411, "name": "based on fairy tale"}, {"id": 179431, "name": "duringcreditsstinger"}, {"id": 215258, "name": "healing gift"}, {"id": 234183, "name": "animal sidekick"}] | en | Tangled | When the kingdom's most wanted-and most charming-bandit Flynn Rider hides out in a mysterious tower, he's taken hostage by Rapunzel, a beautiful and feisty tower-bound teen with 70 feet of magical, golden hair. Flynn's curious captor, who's looking for her ticket out of the tower where she's been locked away for years, strikes a deal with the handsome thief and the unlikely duo sets off on an action-packed escapade, complete with a super-cop horse, an over-protective chameleon and a gruff gang of pub thugs. | 48.681969 | [{"name": "Walt Disney Pictures", "id": 2}, {"name": "Walt Disney Animation Studios", "id": 6125}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2010-11-24 | 591794936 | 100.0 | [English] | Released | They're taking adventure to new lengths. | Tangled | 7.4 | 3330 | 0.74 | 0.055600 | 1 |
| 7 | 280000000 | [Action, Adventure, Science Fiction] | http://marvel.com/movies/movie/193/avengers_age_of_ultron | 99861 | [{"id": 8828, "name": "marvel comic"}, {"id": 9663, "name": "sequel"}, {"id": 9715, "name": "superhero"}, {"id": 9717, "name": "based on comic book"}, {"id": 10629, "name": "vision"}, {"id": 155030, "name": "superhero team"}, {"id": 179431, "name": "duringcreditsstinger"}, {"id": 180547, "name": "marvel cinematic universe"}, {"id": 209714, "name": "3d"}] | en | Avengers: Age of Ultron | When Tony Stark tries to jumpstart a dormant peacekeeping program, things go awry and Earth’s Mightiest Heroes are put to the ultimate test as the fate of the planet hangs in the balance. As the villainous Ultron emerges, it is up to The Avengers to stop him from enacting his terrible plans, and soon uneasy alliances and unexpected action pave the way for an epic and unique global adventure. | 134.279229 | [{"name": "Marvel Studios", "id": 420}, {"name": "Prime Focus", "id": 15357}, {"name": "Revolution Sun Studios", "id": 76043}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2015-04-22 | 1405403694 | 141.0 | [English] | Released | A New Age Has Come. | Avengers: Age of Ultron | 7.3 | 6767 | 0.73 | 0.153360 | 1 |
| 8 | 250000000 | [Adventure, Fantasy, Family] | http://harrypotter.warnerbros.com/harrypotterandthehalf-bloodprince/dvd/index.html | 767 | [{"id": 616, "name": "witch"}, {"id": 2343, "name": "magic"}, {"id": 3872, "name": "broom"}, {"id": 3884, "name": "school of witchcraft"}, {"id": 6333, "name": "wizardry"}, {"id": 10164, "name": "apparition"}, {"id": 10791, "name": "teenage crush"}, {"id": 12564, "name": "werewolf"}] | en | Harry Potter and the Half-Blood Prince | As Harry begins his sixth year at Hogwarts, he discovers an old book marked as 'Property of the Half-Blood Prince', and begins to learn more about Lord Voldemort's dark past. | 98.885637 | [{"name": "Warner Bros.", "id": 6194}, {"name": "Heyday Films", "id": 7364}] | [{"iso_3166_1": "GB", "name": "United Kingdom"}, {"iso_3166_1": "US", "name": "United States of America"}] | 2009-07-07 | 933959197 | 153.0 | [English] | Released | Dark Secrets Revealed | Harry Potter and the Half-Blood Prince | 7.4 | 5293 | 0.74 | 0.112937 | 1 |
| 9 | 250000000 | [Action, Adventure, Fantasy] | http://www.batmanvsupermandawnofjustice.com/ | 209112 | [{"id": 849, "name": "dc comics"}, {"id": 7002, "name": "vigilante"}, {"id": 9715, "name": "superhero"}, {"id": 9717, "name": "based on comic book"}, {"id": 9748, "name": "revenge"}, {"id": 163455, "name": "super powers"}, {"id": 195242, "name": "clark kent"}, {"id": 195243, "name": "bruce wayne"}, {"id": 229266, "name": "dc extended universe"}] | en | Batman v Superman: Dawn of Justice | Fearing the actions of a god-like Super Hero left unchecked, Gotham City’s own formidable, forceful vigilante takes on Metropolis’s most revered, modern-day savior, while the world wrestles with what sort of hero it really needs. And with Batman and Superman at war with one another, a new threat quickly arises, putting mankind in greater danger than it’s ever known before. | 155.790452 | [{"name": "DC Comics", "id": 429}, {"name": "Atlas Entertainment", "id": 507}, {"name": "Warner Bros.", "id": 6194}, {"name": "DC Entertainment", "id": 9993}, {"name": "Cruel & Unusual Films", "id": 9995}, {"name": "RatPac-Dune Entertainment", "id": 41624}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2016-03-23 | 873260194 | 151.0 | [English] | Released | Justice or revenge | Batman v Superman: Dawn of Justice | 5.7 | 7004 | 0.57 | 0.177928 | 0 |
| budget | genres | homepage | id | keywords | original_language | original_title | overview | popularity | production_companies | production_countries | release_date | revenue | runtime | spoken_languages | status | tagline | title | vote_average | vote_count | vote_average_scaled | popularity_scaled | label | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4793 | 0 | [Drama] | NaN | 182291 | [{"id": 718, "name": "confession"}, {"id": 10079, "name": "hazing"}, {"id": 33426, "name": "gang member"}, {"id": 33586, "name": "latino"}, {"id": 158718, "name": "lgbt"}, {"id": 172391, "name": "catholic priest"}, {"id": 196374, "name": "shakespeare's romeo and juliet"}, {"id": 208340, "name": "latino lgbt"}, {"id": 209241, "name": "gang initiation"}, {"id": 209242, "name": "gunplay"}] | en | On The Downlow | Isaac and Angel are two young Latinos involved in a south side Chicago gang. They have a secret in a world where secrets are forbidden. | 0.029757 | [{"name": "Iconoclast Films", "id": 26677}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2004-04-11 | 0 | 90.0 | [] | Released | Two gangs. One secret. One crossroad. | On The Downlow | 6.0 | 2 | 0.60 | 0.000034 | 0 |
| 4794 | 0 | [Thriller, Horror, Comedy] | NaN | 286939 | [] | en | Sanctuary: Quite a Conundrum | It should have been just a normal day of sex, fun, alcohol, hormones and debauchery for Tabitha and Mimi, two over-privileged twenty-somethings. But that so-called normalcy gets tossed out the window when a devastating event occurs at a pool party. | 0.166513 | [{"name": "Gold Lion Films", "id": 37870}, {"name": "T-Street Productions", "id": 37871}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2012-01-20 | 0 | 82.0 | [English] | Released | NaN | Sanctuary: Quite a Conundrum | 0.0 | 0 | 0.00 | 0.000190 | 0 |
| 4795 | 0 | [Drama] | NaN | 124606 | [{"id": 10726, "name": "gang"}, {"id": 33928, "name": "audition"}, {"id": 172732, "name": "police fake"}, {"id": 177927, "name": "homeless"}, {"id": 207583, "name": "actress"}] | en | Bang | A young woman in L.A. is having a bad day: she's evicted, an audition ends with a producer furious she won't trade sex for the part, and a policeman nabs her for something she didn't do, demanding fellatio to release her. She snaps, grabs his gun, takes his uniform, and leaves him cuffed to a tree where he's soon having a defenseless chat with a homeless man. She takes off on the cop's motorcycle and, for an afternoon, experiences a cop's life. She talks a young man out of suicide and then is plunged into violence after a friendly encounter with two "vatos." She is torn between self-protection and others' expectations. Is there any resolution for her torrent of feelings? | 0.918116 | [{"name": "Asylum Films", "id": 10571}, {"name": "FM Entertainment", "id": 26598}, {"name": "Eagle Eye Films Inc.", "id": 40739}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 1995-09-09 | 0 | 98.0 | [English] | Released | Sometimes you've got to break the rules | Bang | 6.0 | 1 | 0.60 | 0.001049 | 0 |
| 4796 | 7000 | [Science Fiction, Drama, Thriller] | http://www.primermovie.com | 14337 | [{"id": 1448, "name": "distrust"}, {"id": 2101, "name": "garage"}, {"id": 3394, "name": "identity crisis"}, {"id": 4379, "name": "time travel"}, {"id": 5455, "name": "time machine"}, {"id": 6009, "name": "mathematics"}, {"id": 10183, "name": "independent film"}, {"id": 14779, "name": "paradox"}, {"id": 162356, "name": "mechanical engineering"}] | en | Primer | Friends/fledgling entrepreneurs invent a device in their garage that reduces the apparent mass of any object placed inside it, but they accidentally discover that it has some highly unexpected capabilities -- ones that could enable them to do and to have seemingly anything they want. Taking advantage of this unique opportunity is the first challenge they face. Dealing with the consequences is the next. | 23.307949 | [{"name": "Thinkfilm", "id": 446}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2004-10-08 | 424760 | 77.0 | [English] | Released | What happens if it actually works? | Primer | 6.9 | 658 | 0.69 | 0.026620 | 1 |
| 4797 | 0 | [Foreign, Thriller] | NaN | 67238 | [] | en | Cavite | Adam, a security guard, travels from California to the Philippines, his native land, for his father's funeral. He arrives in Manila. As he waits, a phone rings in his backpack; he answers it, and a male voice tells him that his mother and sister are captives and will be killed if Adam doesn't cooperate. Over the next hour, the voice sends Adam by bus, taxi, motorized tricycle, and on foot through an urban landscape of busy streets, cramped apartments, a fetid squatters' camp, a bank, a cockfighting arena, and a church. Adam's conversations with the voice cover murder, Islam, jihad, rebellion in Mindanao, and his family. What is it Adam will be commanded to do? | 0.022173 | [] | [] | 2005-03-12 | 0 | 80.0 | [] | Released | NaN | Cavite | 7.5 | 2 | 0.75 | 0.000025 | 1 |
| 4798 | 220000 | [Action, Crime, Thriller] | NaN | 9367 | [{"id": 5616, "name": "united states\u2013mexico barrier"}, {"id": 33649, "name": "legs"}, {"id": 162740, "name": "arms"}, {"id": 187891, "name": "paper knife"}, {"id": 206558, "name": "guitar case"}] | es | El Mariachi | El Mariachi just wants to play his guitar and carry on the family tradition. Unfortunately, the town he tries to find work in has another visitor...a killer who carries his guns in a guitar case. The drug lord and his henchmen mistake El Mariachi for the killer, Azul, and chase him around town trying to kill him and get his guitar case. | 14.269792 | [{"name": "Columbia Pictures", "id": 5}] | [{"iso_3166_1": "MX", "name": "Mexico"}, {"iso_3166_1": "US", "name": "United States of America"}] | 1992-09-04 | 2040920 | 81.0 | [Español] | Released | He didn't come looking for trouble, but trouble came looking for him. | El Mariachi | 6.6 | 238 | 0.66 | 0.016298 | 1 |
| 4799 | 9000 | [Comedy, Romance] | NaN | 72766 | [] | en | Newlyweds | A newlywed couple's honeymoon is upended by the arrivals of their respective sisters. | 0.642552 | [] | [] | 2011-12-26 | 0 | 85.0 | [] | Released | A newlywed couple's honeymoon is upended by the arrivals of their respective sisters. | Newlyweds | 5.9 | 5 | 0.59 | 0.000734 | 0 |
| 4800 | 0 | [Comedy, Drama, Romance, TV Movie] | http://www.hallmarkchannel.com/signedsealeddelivered | 231617 | [{"id": 248, "name": "date"}, {"id": 699, "name": "love at first sight"}, {"id": 2398, "name": "narration"}, {"id": 5340, "name": "investigation"}, {"id": 34051, "name": "team"}, {"id": 173066, "name": "postal worker"}] | en | Signed, Sealed, Delivered | "Signed, Sealed, Delivered" introduces a dedicated quartet of civil servants in the Dead Letter Office of the U.S. Postal System who transform themselves into an elite team of lost-mail detectives. Their determination to deliver the seemingly undeliverable takes them out of the post office into an unpredictable world where letters and packages from the past save lives, solve crimes, reunite old loves, and change futures by arriving late, but always miraculously on time. | 1.444476 | [{"name": "Front Street Pictures", "id": 3958}, {"name": "Muse Entertainment Enterprises", "id": 6438}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2013-10-13 | 0 | 120.0 | [English] | Released | NaN | Signed, Sealed, Delivered | 7.0 | 6 | 0.70 | 0.001650 | 1 |
| 4801 | 0 | [] | http://shanghaicalling.com/ | 126186 | [] | en | Shanghai Calling | When ambitious New York attorney Sam is sent to Shanghai on assignment, he immediately stumbles into a legal mess that could end his career. With the help of a beautiful relocation specialist, a well-connected old-timer, a clever journalist, and a street-smart legal assistant, Sam might just save his job, find romance, and learn to appreciate the beauty and wonders of Shanghai. Written by Anonymous (IMDB.com). | 0.857008 | [] | [{"iso_3166_1": "US", "name": "United States of America"}, {"iso_3166_1": "CN", "name": "China"}] | 2012-05-03 | 0 | 98.0 | [English] | Released | A New Yorker in Shanghai | Shanghai Calling | 5.7 | 7 | 0.57 | 0.000979 | 0 |
| 4802 | 0 | [Documentary] | NaN | 25975 | [{"id": 1523, "name": "obsession"}, {"id": 2249, "name": "camcorder"}, {"id": 9986, "name": "crush"}, {"id": 11223, "name": "dream girl"}] | en | My Date with Drew | Ever since the second grade when he first saw her in E.T. The Extraterrestrial, Brian Herzlinger has had a crush on Drew Barrymore. Now, 20 years later he's decided to try to fulfill his lifelong dream by asking her for a date. There's one small problem: She's Drew Barrymore and he's, well, Brian Herzlinger, a broke 27-year-old aspiring filmmaker from New Jersey. | 1.929883 | [{"name": "rusty bear entertainment", "id": 87986}, {"name": "lucky crow films", "id": 87987}] | [{"iso_3166_1": "US", "name": "United States of America"}] | 2005-08-05 | 0 | 90.0 | [English] | Released | NaN | My Date with Drew | 6.3 | 16 | 0.63 | 0.002204 | 1 |